Dataset statistics
| Number of variables | 24 |
|---|---|
| Number of observations | 6743404 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 31 |
| Duplicate rows (%) | < 0.1% |
| Total size in memory | 6.0 GiB |
| Average record size in memory | 955.0 B |
Variable types
| DateTime | 1 |
|---|---|
| Numeric | 10 |
| Categorical | 8 |
| Text | 5 |
| Dataset has 31 (< 0.1%) duplicate rows | Duplicates |
distance_type is highly imbalanced (64.0%) | Imbalance |
delay_carrier is highly skewed (γ1 = 22.75356143) | Skewed |
delay_weather is highly skewed (γ1 = 45.85829053) | Skewed |
delay_nas is highly skewed (γ1 = 22.64631668) | Skewed |
delay_security is highly skewed (γ1 = 288.4643263) | Skewed |
dep_delay has 314587 (4.7%) zeros | Zeros |
arr_delay has 124753 (1.9%) zeros | Zeros |
delay_carrier has 5955514 (88.3%) zeros | Zeros |
delay_weather has 6671405 (98.9%) zeros | Zeros |
delay_nas has 6082619 (90.2%) zeros | Zeros |
delay_security has 6735256 (99.9%) zeros | Zeros |
delay_lastaircraft has 6032286 (89.5%) zeros | Zeros |
Reproduction
| Analysis started | 2024-06-17 11:51:53.295062 |
|---|---|
| Analysis finished | 2024-06-17 11:53:57.198842 |
| Duration | 2 minutes and 3.9 seconds |
| Software version | ydata-profiling v4.8.3 |
| Download configuration | config.json |
flightdate
Date
| Distinct | 365 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 51.4 MiB |
| Minimum | 2023-01-01 00:00:00 |
|---|---|
| Maximum | 2023-12-31 00:00:00 |
day_of_week
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.9827933 |
| Minimum | 1 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 51.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 6 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.0017618 |
|---|---|
| Coefficient of variation (CV) | 0.50260249 |
| Kurtosis | -1.2323597 |
| Mean | 3.9827933 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.011062589 |
| Sum | 26857584 |
| Variance | 4.0070504 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 1003622 | |
| 4 | 998363 | |
| 1 | 996633 | |
| 7 | 984934 | |
| 3 | 951327 | |
| 2 | 937570 | |
| 6 | 870955 |
| Value | Count | Frequency (%) |
| 1 | 996633 | |
| 2 | 937570 | |
| 3 | 951327 | |
| 4 | 998363 | |
| 5 | 1003622 | |
| 6 | 870955 | |
| 7 | 984934 |
| Value | Count | Frequency (%) |
| 7 | 984934 | |
| 6 | 870955 | |
| 5 | 1003622 | |
| 4 | 998363 | |
| 3 | 951327 | |
| 2 | 937570 | |
| 1 | 996633 |
airline
Categorical
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 495.2 MiB |
| Southwest Airlines Co. | |
|---|---|
| Delta Air Lines Inc | |
| American Airlines Inc. | |
| United Air Lines Inc. | |
| Skywest Airlines Inc. | |
| Other values (10) |
Length
| Max length | 28 |
|---|---|
| Median length | 22 |
| Mean length | 19.998374 |
| Min length | 12 |
Characters and Unicode
| Total characters | 134857118 |
|---|---|
| Distinct characters | 37 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Endeavor Air |
|---|---|
| 2nd row | Endeavor Air |
| 3rd row | Endeavor Air |
| 4th row | Endeavor Air |
| 5th row | Endeavor Air |
Common Values
| Value | Count | Frequency (%) |
| Southwest Airlines Co. | 1421238 | |
| Delta Air Lines Inc | 972931 | |
| American Airlines Inc. | 928058 | |
| United Air Lines Inc. | 720032 | |
| Skywest Airlines Inc. | 664861 | |
| Republic Airways | 286490 | 4.2% |
| JetBlue Airways | 267915 | 4.0% |
| Spirit Air Lines | 258838 | 3.8% |
| Alaska Airlines Inc. | 242643 | 3.6% |
| American Eagle Airlines Inc. | 224695 | 3.3% |
| Other values (5) | 755703 |
Length
| Value | Count | Frequency (%) |
| inc | 4006521 | |
| airlines | 3925868 | |
| air | 2263131 | |
| lines | 1951801 | |
| southwest | 1421238 | 6.7% |
| co | 1421238 | 6.7% |
| american | 1152753 | 5.5% |
| delta | 972931 | 4.6% |
| united | 720032 | 3.4% |
| skywest | 664861 | 3.2% |
| Other values (11) | 2590689 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 15745592 | |
| 14347659 | 10.6% | |
| e | 12341288 | 9.2% |
| n | 12321606 | 9.1% |
| s | 8760816 | 6.5% |
| r | 8698818 | 6.5% |
| A | 8444297 | 6.3% |
| l | 6149392 | 4.6% |
| t | 6014937 | 4.5% |
| c | 5445764 | 4.0% |
| Other values (27) | 36586949 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 134857118 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 15745592 | |
| 14347659 | 10.6% | |
| e | 12341288 | 9.2% |
| n | 12321606 | 9.1% |
| s | 8760816 | 6.5% |
| r | 8698818 | 6.5% |
| A | 8444297 | 6.3% |
| l | 6149392 | 4.6% |
| t | 6014937 | 4.5% |
| c | 5445764 | 4.0% |
| Other values (27) | 36586949 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 134857118 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 15745592 | |
| 14347659 | 10.6% | |
| e | 12341288 | 9.2% |
| n | 12321606 | 9.1% |
| s | 8760816 | 6.5% |
| r | 8698818 | 6.5% |
| A | 8444297 | 6.3% |
| l | 6149392 | 4.6% |
| t | 6014937 | 4.5% |
| c | 5445764 | 4.0% |
| Other values (27) | 36586949 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 134857118 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 15745592 | |
| 14347659 | 10.6% | |
| e | 12341288 | 9.2% |
| n | 12321606 | 9.1% |
| s | 8760816 | 6.5% |
| r | 8698818 | 6.5% |
| A | 8444297 | 6.3% |
| l | 6149392 | 4.6% |
| t | 6014937 | 4.5% |
| c | 5445764 | 4.0% |
| Other values (27) | 36586949 |
tail_number
Text
| Distinct | 5963 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 405.1 MiB |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.997429 |
| Min length | 2 |
Characters and Unicode
| Total characters | 40443087 |
|---|---|
| Distinct characters | 35 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | N605LR |
|---|---|
| 2nd row | N605LR |
| 3rd row | N331PQ |
| 4th row | N906XJ |
| 5th row | N337PQ |
| Value | Count | Frequency (%) |
| n488ha | 3327 | < 0.1% |
| n487ha | 3315 | < 0.1% |
| n486ha | 3306 | < 0.1% |
| n483ha | 3222 | < 0.1% |
| n484ha | 3221 | < 0.1% |
| n485ha | 3199 | < 0.1% |
| n479ha | 3190 | < 0.1% |
| n475ha | 3160 | < 0.1% |
| n495ha | 3150 | < 0.1% |
| n480ha | 3107 | < 0.1% |
| Other values (5953) | 6711207 |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 9256873 | |
| 8 | 2779496 | 6.9% |
| 7 | 2486728 | 6.1% |
| 2 | 2477915 | 6.1% |
| 3 | 2475189 | 6.1% |
| 5 | 2146884 | 5.3% |
| 1 | 2140191 | 5.3% |
| 9 | 2098277 | 5.2% |
| 6 | 2056955 | 5.1% |
| 4 | 2047117 | 5.1% |
| Other values (25) | 10477462 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 40443087 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| N | 9256873 | |
| 8 | 2779496 | 6.9% |
| 7 | 2486728 | 6.1% |
| 2 | 2477915 | 6.1% |
| 3 | 2475189 | 6.1% |
| 5 | 2146884 | 5.3% |
| 1 | 2140191 | 5.3% |
| 9 | 2098277 | 5.2% |
| 6 | 2056955 | 5.1% |
| 4 | 2047117 | 5.1% |
| Other values (25) | 10477462 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 40443087 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| N | 9256873 | |
| 8 | 2779496 | 6.9% |
| 7 | 2486728 | 6.1% |
| 2 | 2477915 | 6.1% |
| 3 | 2475189 | 6.1% |
| 5 | 2146884 | 5.3% |
| 1 | 2140191 | 5.3% |
| 9 | 2098277 | 5.2% |
| 6 | 2056955 | 5.1% |
| 4 | 2047117 | 5.1% |
| Other values (25) | 10477462 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 40443087 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| N | 9256873 | |
| 8 | 2779496 | 6.9% |
| 7 | 2486728 | 6.1% |
| 2 | 2477915 | 6.1% |
| 3 | 2475189 | 6.1% |
| 5 | 2146884 | 5.3% |
| 1 | 2140191 | 5.3% |
| 9 | 2098277 | 5.2% |
| 6 | 2056955 | 5.1% |
| 4 | 2047117 | 5.1% |
| Other values (25) | 10477462 |
dep_airport
Text
| Distinct | 350 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 385.9 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 20230212 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BDL |
|---|---|
| 2nd row | BDL |
| 3rd row | BDL |
| 4th row | BDL |
| 5th row | BDL |
| Value | Count | Frequency (%) |
| atl | 332935 | 4.9% |
| den | 284200 | 4.2% |
| dfw | 280021 | 4.2% |
| ord | 255071 | 3.8% |
| clt | 192870 | 2.9% |
| lax | 192260 | 2.9% |
| las | 188206 | 2.8% |
| phx | 175144 | 2.6% |
| sea | 162441 | 2.4% |
| mco | 161846 | 2.4% |
| Other values (340) | 4518410 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 2310561 | 11.4% |
| L | 1868924 | 9.2% |
| S | 1731888 | 8.6% |
| D | 1586090 | 7.8% |
| T | 1071694 | 5.3% |
| O | 1033706 | 5.1% |
| C | 1021112 | 5.0% |
| M | 905267 | 4.5% |
| F | 835550 | 4.1% |
| W | 789662 | 3.9% |
| Other values (16) | 7075758 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 20230212 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 2310561 | 11.4% |
| L | 1868924 | 9.2% |
| S | 1731888 | 8.6% |
| D | 1586090 | 7.8% |
| T | 1071694 | 5.3% |
| O | 1033706 | 5.1% |
| C | 1021112 | 5.0% |
| M | 905267 | 4.5% |
| F | 835550 | 4.1% |
| W | 789662 | 3.9% |
| Other values (16) | 7075758 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 20230212 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 2310561 | 11.4% |
| L | 1868924 | 9.2% |
| S | 1731888 | 8.6% |
| D | 1586090 | 7.8% |
| T | 1071694 | 5.3% |
| O | 1033706 | 5.1% |
| C | 1021112 | 5.0% |
| M | 905267 | 4.5% |
| F | 835550 | 4.1% |
| W | 789662 | 3.9% |
| Other values (16) | 7075758 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 20230212 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 2310561 | 11.4% |
| L | 1868924 | 9.2% |
| S | 1731888 | 8.6% |
| D | 1586090 | 7.8% |
| T | 1071694 | 5.3% |
| O | 1033706 | 5.1% |
| C | 1021112 | 5.0% |
| M | 905267 | 4.5% |
| F | 835550 | 4.1% |
| W | 789662 | 3.9% |
| Other values (16) | 7075758 |
dep_cityname
Text
| Distinct | 344 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 450.5 MiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.045103 |
| Min length | 8 |
Characters and Unicode
| Total characters | 87968400 |
|---|---|
| Distinct characters | 57 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Hartford, CT |
|---|---|
| 2nd row | Hartford, CT |
| 3rd row | Hartford, CT |
| 4th row | Hartford, CT |
| 5th row | Hartford, CT |
| Value | Count | Frequency (%) |
| ca | 729627 | 4.6% |
| tx | 707555 | 4.5% |
| fl | 600100 | 3.8% |
| ny | 367049 | 2.3% |
| ga | 357008 | 2.3% |
| san | 352217 | 2.2% |
| il | 351390 | 2.2% |
| chicago | 338766 | 2.2% |
| new | 337488 | 2.1% |
| atlanta | 332935 | 2.1% |
| Other values (418) | 11242964 |
Most occurring characters
| Value | Count | Frequency (%) |
| 8973695 | 10.2% | |
| , | 6743404 | 7.7% |
| a | 6726644 | 7.6% |
| o | 4843270 | 5.5% |
| e | 4645987 | 5.3% |
| n | 4315860 | 4.9% |
| t | 4204810 | 4.8% |
| l | 3879759 | 4.4% |
| i | 3337094 | 3.8% |
| r | 3178163 | 3.6% |
| Other values (47) | 37119714 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 87968400 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 8973695 | 10.2% | |
| , | 6743404 | 7.7% |
| a | 6726644 | 7.6% |
| o | 4843270 | 5.5% |
| e | 4645987 | 5.3% |
| n | 4315860 | 4.9% |
| t | 4204810 | 4.8% |
| l | 3879759 | 4.4% |
| i | 3337094 | 3.8% |
| r | 3178163 | 3.6% |
| Other values (47) | 37119714 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 87968400 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 8973695 | 10.2% | |
| , | 6743404 | 7.7% |
| a | 6726644 | 7.6% |
| o | 4843270 | 5.5% |
| e | 4645987 | 5.3% |
| n | 4315860 | 4.9% |
| t | 4204810 | 4.8% |
| l | 3879759 | 4.4% |
| i | 3337094 | 3.8% |
| r | 3178163 | 3.6% |
| Other values (47) | 37119714 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 87968400 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 8973695 | 10.2% | |
| , | 6743404 | 7.7% |
| a | 6726644 | 7.6% |
| o | 4843270 | 5.5% |
| e | 4645987 | 5.3% |
| n | 4315860 | 4.9% |
| t | 4204810 | 4.8% |
| l | 3879759 | 4.4% |
| i | 3337094 | 3.8% |
| r | 3178163 | 3.6% |
| Other values (47) | 37119714 |
deptime_label
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 415.7 MiB |
| Morning | |
|---|---|
| Afternoon | |
| Evening | |
| Night | 211159 |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 7.6383129 |
| Min length | 5 |
Characters and Unicode
| Total characters | 51508230 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Morning |
|---|---|
| 2nd row | Morning |
| 3rd row | Morning |
| 4th row | Morning |
| 5th row | Morning |
Common Values
| Value | Count | Frequency (%) |
| Morning | 2611567 | |
| Afternoon | 2363360 | |
| Evening | 1557318 | |
| Night | 211159 | 3.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| morning | 2611567 | |
| afternoon | 2363360 | |
| evening | 1557318 | |
| night | 211159 | 3.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 13064490 | |
| o | 7338287 | |
| r | 4974927 | 9.7% |
| i | 4380044 | 8.5% |
| g | 4380044 | 8.5% |
| e | 3920678 | 7.6% |
| M | 2611567 | 5.1% |
| t | 2574519 | 5.0% |
| A | 2363360 | 4.6% |
| f | 2363360 | 4.6% |
| Other values (4) | 3536954 | 6.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 51508230 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| n | 13064490 | |
| o | 7338287 | |
| r | 4974927 | 9.7% |
| i | 4380044 | 8.5% |
| g | 4380044 | 8.5% |
| e | 3920678 | 7.6% |
| M | 2611567 | 5.1% |
| t | 2574519 | 5.0% |
| A | 2363360 | 4.6% |
| f | 2363360 | 4.6% |
| Other values (4) | 3536954 | 6.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 51508230 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| n | 13064490 | |
| o | 7338287 | |
| r | 4974927 | 9.7% |
| i | 4380044 | 8.5% |
| g | 4380044 | 8.5% |
| e | 3920678 | 7.6% |
| M | 2611567 | 5.1% |
| t | 2574519 | 5.0% |
| A | 2363360 | 4.6% |
| f | 2363360 | 4.6% |
| Other values (4) | 3536954 | 6.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 51508230 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| n | 13064490 | |
| o | 7338287 | |
| r | 4974927 | 9.7% |
| i | 4380044 | 8.5% |
| g | 4380044 | 8.5% |
| e | 3920678 | 7.6% |
| M | 2611567 | 5.1% |
| t | 2574519 | 5.0% |
| A | 2363360 | 4.6% |
| f | 2363360 | 4.6% |
| Other values (4) | 3536954 | 6.9% |
dep_delay
Real number (ℝ)
ZEROS 
| Distinct | 1854 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.200987 |
| Minimum | -99 |
|---|---|
| Maximum | 4413 |
| Zeros | 314587 |
| Zeros (%) | 4.7% |
| Negative | 3873058 |
| Negative (%) | 57.4% |
| Memory size | 51.4 MiB |
Quantile statistics
| Minimum | -99 |
|---|---|
| 5-th percentile | -10 |
| Q1 | -5 |
| median | -2 |
| Q3 | 9 |
| 95-th percentile | 78 |
| Maximum | 4413 |
| Range | 4512 |
| Interquartile range (IQR) | 14 |
Descriptive statistics
| Standard deviation | 55.079361 |
|---|---|
| Coefficient of variation (CV) | 4.5143367 |
| Kurtosis | 268.2125 |
| Mean | 12.200987 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 12.011317 |
| Sum | 82276182 |
| Variance | 3033.736 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -5 | 504339 | 7.5% |
| -4 | 470790 | 7.0% |
| -3 | 455316 | 6.8% |
| -2 | 413304 | 6.1% |
| -6 | 402407 | 6.0% |
| -1 | 369791 | 5.5% |
| -7 | 340582 | 5.1% |
| 0 | 314587 | 4.7% |
| -8 | 272735 | 4.0% |
| -9 | 202664 | 3.0% |
| Other values (1844) | 2996889 |
| Value | Count | Frequency (%) |
| -99 | 1 | < 0.1% |
| -72 | 1 | < 0.1% |
| -68 | 1 | < 0.1% |
| -59 | 3 | |
| -55 | 1 | < 0.1% |
| -53 | 1 | < 0.1% |
| -52 | 2 | |
| -51 | 1 | < 0.1% |
| -50 | 1 | < 0.1% |
| -49 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 4413 | 1 | |
| 3786 | 1 | |
| 3695 | 1 | |
| 3518 | 1 | |
| 3445 | 1 | |
| 3343 | 1 | |
| 3249 | 1 | |
| 3238 | 1 | |
| 3221 | 1 | |
| 3024 | 1 |
dep_delay_tag
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 373.0 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 6743404 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 4187645 | |
| 1 | 2555759 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 4187645 | |
| 1 | 2555759 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 4187645 | |
| 1 | 2555759 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 6743404 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 4187645 | |
| 1 | 2555759 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 6743404 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 4187645 | |
| 1 | 2555759 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 6743404 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 4187645 | |
| 1 | 2555759 |
dep_delay_type
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 429.1 MiB |
| Low <5min | |
|---|---|
| Medium >15min | |
| Hight >60min | 455669 |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 9.7235217 |
| Min length | 9 |
Characters and Unicode
| Total characters | 65569635 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Low <5min |
|---|---|
| 2nd row | Low <5min |
| 3rd row | Low <5min |
| 4th row | Low <5min |
| 5th row | Low <5min |
Common Values
| Value | Count | Frequency (%) |
| Low <5min | 5409737 | |
| Medium >15min | 877998 | 13.0% |
| Hight >60min | 455669 | 6.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| low | 5409737 | |
| 5min | 5409737 | |
| medium | 877998 | 6.5% |
| 15min | 877998 | 6.5% |
| hight | 455669 | 3.4% |
| 60min | 455669 | 3.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 8077071 | |
| m | 7621402 | |
| 6743404 | ||
| n | 6743404 | |
| 5 | 6287735 | |
| L | 5409737 | |
| w | 5409737 | |
| < | 5409737 | |
| o | 5409737 | |
| > | 1333667 | 2.0% |
| Other values (11) | 7124004 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 65569635 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 8077071 | |
| m | 7621402 | |
| 6743404 | ||
| n | 6743404 | |
| 5 | 6287735 | |
| L | 5409737 | |
| w | 5409737 | |
| < | 5409737 | |
| o | 5409737 | |
| > | 1333667 | 2.0% |
| Other values (11) | 7124004 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 65569635 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 8077071 | |
| m | 7621402 | |
| 6743404 | ||
| n | 6743404 | |
| 5 | 6287735 | |
| L | 5409737 | |
| w | 5409737 | |
| < | 5409737 | |
| o | 5409737 | |
| > | 1333667 | 2.0% |
| Other values (11) | 7124004 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 65569635 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 8077071 | |
| m | 7621402 | |
| 6743404 | ||
| n | 6743404 | |
| 5 | 6287735 | |
| L | 5409737 | |
| w | 5409737 | |
| < | 5409737 | |
| o | 5409737 | |
| > | 1333667 | 2.0% |
| Other values (11) | 7124004 |
arr_airport
Text
| Distinct | 350 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 385.9 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 20230212 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | LGA |
|---|---|
| 2nd row | LGA |
| 3rd row | LGA |
| 4th row | LGA |
| 5th row | LGA |
| Value | Count | Frequency (%) |
| atl | 332941 | 4.9% |
| den | 283563 | 4.2% |
| dfw | 279733 | 4.1% |
| ord | 254775 | 3.8% |
| clt | 192911 | 2.9% |
| lax | 192417 | 2.9% |
| las | 188243 | 2.8% |
| phx | 175196 | 2.6% |
| sea | 162323 | 2.4% |
| mco | 161373 | 2.4% |
| Other values (340) | 4519929 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 2310587 | 11.4% |
| L | 1868994 | 9.2% |
| S | 1733227 | 8.6% |
| D | 1584874 | 7.8% |
| T | 1072291 | 5.3% |
| O | 1032990 | 5.1% |
| C | 1021074 | 5.0% |
| M | 904967 | 4.5% |
| F | 835174 | 4.1% |
| W | 789110 | 3.9% |
| Other values (16) | 7076924 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 20230212 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 2310587 | 11.4% |
| L | 1868994 | 9.2% |
| S | 1733227 | 8.6% |
| D | 1584874 | 7.8% |
| T | 1072291 | 5.3% |
| O | 1032990 | 5.1% |
| C | 1021074 | 5.0% |
| M | 904967 | 4.5% |
| F | 835174 | 4.1% |
| W | 789110 | 3.9% |
| Other values (16) | 7076924 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 20230212 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 2310587 | 11.4% |
| L | 1868994 | 9.2% |
| S | 1733227 | 8.6% |
| D | 1584874 | 7.8% |
| T | 1072291 | 5.3% |
| O | 1032990 | 5.1% |
| C | 1021074 | 5.0% |
| M | 904967 | 4.5% |
| F | 835174 | 4.1% |
| W | 789110 | 3.9% |
| Other values (16) | 7076924 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 20230212 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 2310587 | 11.4% |
| L | 1868994 | 9.2% |
| S | 1733227 | 8.6% |
| D | 1584874 | 7.8% |
| T | 1072291 | 5.3% |
| O | 1032990 | 5.1% |
| C | 1021074 | 5.0% |
| M | 904967 | 4.5% |
| F | 835174 | 4.1% |
| W | 789110 | 3.9% |
| Other values (16) | 7076924 |
arr_cityname
Text
| Distinct | 344 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 450.5 MiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.045968 |
| Min length | 8 |
Characters and Unicode
| Total characters | 87974235 |
|---|---|
| Distinct characters | 57 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New York, NY |
|---|---|
| 2nd row | New York, NY |
| 3rd row | New York, NY |
| 4th row | New York, NY |
| 5th row | New York, NY |
| Value | Count | Frequency (%) |
| ca | 730230 | 4.6% |
| tx | 707058 | 4.5% |
| fl | 599542 | 3.8% |
| ny | 366899 | 2.3% |
| ga | 357014 | 2.3% |
| san | 352645 | 2.2% |
| il | 350948 | 2.2% |
| chicago | 338319 | 2.2% |
| new | 337294 | 2.1% |
| atlanta | 332941 | 2.1% |
| Other values (418) | 11245209 |
Most occurring characters
| Value | Count | Frequency (%) |
| 8974695 | 10.2% | |
| , | 6743404 | 7.7% |
| a | 6727616 | 7.6% |
| o | 4842443 | 5.5% |
| e | 4646574 | 5.3% |
| n | 4316955 | 4.9% |
| t | 4205119 | 4.8% |
| l | 3880082 | 4.4% |
| i | 3338106 | 3.8% |
| r | 3176719 | 3.6% |
| Other values (47) | 37122522 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 87974235 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 8974695 | 10.2% | |
| , | 6743404 | 7.7% |
| a | 6727616 | 7.6% |
| o | 4842443 | 5.5% |
| e | 4646574 | 5.3% |
| n | 4316955 | 4.9% |
| t | 4205119 | 4.8% |
| l | 3880082 | 4.4% |
| i | 3338106 | 3.8% |
| r | 3176719 | 3.6% |
| Other values (47) | 37122522 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 87974235 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 8974695 | 10.2% | |
| , | 6743404 | 7.7% |
| a | 6727616 | 7.6% |
| o | 4842443 | 5.5% |
| e | 4646574 | 5.3% |
| n | 4316955 | 4.9% |
| t | 4205119 | 4.8% |
| l | 3880082 | 4.4% |
| i | 3338106 | 3.8% |
| r | 3176719 | 3.6% |
| Other values (47) | 37122522 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 87974235 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 8974695 | 10.2% | |
| , | 6743404 | 7.7% |
| a | 6727616 | 7.6% |
| o | 4842443 | 5.5% |
| e | 4646574 | 5.3% |
| n | 4316955 | 4.9% |
| t | 4205119 | 4.8% |
| l | 3880082 | 4.4% |
| i | 3338106 | 3.8% |
| r | 3176719 | 3.6% |
| Other values (47) | 37122522 |
arr_delay
Real number (ℝ)
ZEROS 
| Distinct | 1880 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.6271515 |
| Minimum | -119 |
|---|---|
| Maximum | 4405 |
| Zeros | 124753 |
| Zeros (%) | 1.9% |
| Negative | 4146121 |
| Negative (%) | 61.5% |
| Memory size | 51.4 MiB |
Quantile statistics
| Minimum | -119 |
|---|---|
| 5-th percentile | -27 |
| Q1 | -15 |
| median | -6 |
| Q3 | 9 |
| 95-th percentile | 78 |
| Maximum | 4405 |
| Range | 4524 |
| Interquartile range (IQR) | 24 |
Descriptive statistics
| Standard deviation | 57.078921 |
|---|---|
| Coefficient of variation (CV) | 8.6128892 |
| Kurtosis | 235.04159 |
| Mean | 6.6271515 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | 10.934348 |
| Sum | 44689560 |
| Variance | 3258.0033 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -11 | 189215 | 2.8% |
| -10 | 189118 | 2.8% |
| -12 | 188072 | 2.8% |
| -9 | 185850 | 2.8% |
| -13 | 184325 | 2.7% |
| -8 | 182425 | 2.7% |
| -14 | 179315 | 2.7% |
| -7 | 176693 | 2.6% |
| -15 | 172031 | 2.6% |
| -6 | 170461 | 2.5% |
| Other values (1870) | 4925899 |
| Value | Count | Frequency (%) |
| -119 | 1 | < 0.1% |
| -98 | 1 | < 0.1% |
| -97 | 1 | < 0.1% |
| -96 | 1 | < 0.1% |
| -94 | 1 | < 0.1% |
| -92 | 2 | < 0.1% |
| -91 | 1 | < 0.1% |
| -89 | 1 | < 0.1% |
| -88 | 1 | < 0.1% |
| -86 | 5 |
| Value | Count | Frequency (%) |
| 4405 | 1 | |
| 3795 | 1 | |
| 3680 | 1 | |
| 3502 | 1 | |
| 3424 | 1 | |
| 3337 | 1 | |
| 3246 | 1 | |
| 3241 | 1 | |
| 3237 | 1 | |
| 3063 | 1 |
arr_delay_type
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 429.1 MiB |
| Low <5min | |
|---|---|
| Medium >15min | |
| Hight >60min | 453687 |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 9.7273806 |
| Min length | 9 |
Characters and Unicode
| Total characters | 65595657 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Low <5min |
|---|---|
| 2nd row | Low <5min |
| 3rd row | Low <5min |
| 4th row | Low <5min |
| 5th row | Low <5min |
Common Values
| Value | Count | Frequency (%) |
| Low <5min | 5403727 | |
| Medium >15min | 885990 | 13.1% |
| Hight >60min | 453687 | 6.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| low | 5403727 | |
| 5min | 5403727 | |
| medium | 885990 | 6.6% |
| 15min | 885990 | 6.6% |
| hight | 453687 | 3.4% |
| 60min | 453687 | 3.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 8083081 | |
| m | 7629394 | |
| 6743404 | ||
| n | 6743404 | |
| 5 | 6289717 | |
| L | 5403727 | |
| w | 5403727 | |
| < | 5403727 | |
| o | 5403727 | |
| > | 1339677 | 2.0% |
| Other values (11) | 7152072 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 65595657 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 8083081 | |
| m | 7629394 | |
| 6743404 | ||
| n | 6743404 | |
| 5 | 6289717 | |
| L | 5403727 | |
| w | 5403727 | |
| < | 5403727 | |
| o | 5403727 | |
| > | 1339677 | 2.0% |
| Other values (11) | 7152072 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 65595657 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 8083081 | |
| m | 7629394 | |
| 6743404 | ||
| n | 6743404 | |
| 5 | 6289717 | |
| L | 5403727 | |
| w | 5403727 | |
| < | 5403727 | |
| o | 5403727 | |
| > | 1339677 | 2.0% |
| Other values (11) | 7152072 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 65595657 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 8083081 | |
| m | 7629394 | |
| 6743404 | ||
| n | 6743404 | |
| 5 | 6289717 | |
| L | 5403727 | |
| w | 5403727 | |
| < | 5403727 | |
| o | 5403727 | |
| > | 1339677 | 2.0% |
| Other values (11) | 7152072 |
flight_duration
Real number (ℝ)
| Distinct | 724 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 140.29778 |
| Minimum | 0 |
|---|---|
| Maximum | 795 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 51.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 58 |
| Q1 | 87 |
| median | 124 |
| Q3 | 171 |
| 95-th percentile | 298 |
| Maximum | 795 |
| Range | 795 |
| Interquartile range (IQR) | 84 |
Descriptive statistics
| Standard deviation | 72.872157 |
|---|---|
| Coefficient of variation (CV) | 0.51941063 |
| Kurtosis | 2.4147395 |
| Mean | 140.29778 |
| Median Absolute Deviation (MAD) | 41 |
| Skewness | 1.3861561 |
| Sum | 9.460846 × 108 |
| Variance | 5310.3513 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 81 | 53005 | 0.8% |
| 82 | 52586 | 0.8% |
| 79 | 52293 | 0.8% |
| 80 | 52180 | 0.8% |
| 83 | 51944 | 0.8% |
| 78 | 51746 | 0.8% |
| 84 | 51544 | 0.8% |
| 77 | 51196 | 0.8% |
| 85 | 51030 | 0.8% |
| 76 | 50814 | 0.8% |
| Other values (714) | 6225066 |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 15 | 3 | < 0.1% |
| 16 | 9 | < 0.1% |
| 17 | 28 | < 0.1% |
| 18 | 36 | |
| 19 | 45 | |
| 20 | 49 | |
| 21 | 65 | |
| 22 | 81 | |
| 23 | 73 |
| Value | Count | Frequency (%) |
| 795 | 1 | |
| 759 | 1 | |
| 749 | 1 | |
| 744 | 1 | |
| 742 | 2 | |
| 736 | 1 | |
| 735 | 2 | |
| 734 | 1 | |
| 732 | 1 | |
| 731 | 1 |
distance_type
Categorical
IMBALANCE 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 483.1 MiB |
| Short Haul >1500Mi | |
|---|---|
| Medium Haul <3000Mi | |
| Long Haul <6000Mi | 14061 |
Length
| Max length | 19 |
|---|---|
| Median length | 18 |
| Mean length | 18.125029 |
| Min length | 17 |
Characters and Unicode
| Total characters | 122224395 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Short Haul >1500Mi |
|---|---|
| 2nd row | Short Haul >1500Mi |
| 3rd row | Short Haul >1500Mi |
| 4th row | Short Haul >1500Mi |
| 5th row | Short Haul >1500Mi |
Common Values
| Value | Count | Frequency (%) |
| Short Haul >1500Mi | 5872159 | |
| Medium Haul <3000Mi | 857184 | 12.7% |
| Long Haul <6000Mi | 14061 | 0.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| haul | 6743404 | |
| short | 5872159 | |
| 1500mi | 5872159 | |
| medium | 857184 | 4.2% |
| 3000mi | 857184 | 4.2% |
| long | 14061 | 0.1% |
| 6000mi | 14061 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 14358053 | 11.7% |
| 13486808 | 11.0% | |
| i | 7600588 | 6.2% |
| M | 7600588 | 6.2% |
| u | 7600588 | 6.2% |
| H | 6743404 | 5.5% |
| a | 6743404 | 5.5% |
| l | 6743404 | 5.5% |
| o | 5886220 | 4.8% |
| S | 5872159 | 4.8% |
| Other values (15) | 39589179 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 122224395 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 14358053 | 11.7% |
| 13486808 | 11.0% | |
| i | 7600588 | 6.2% |
| M | 7600588 | 6.2% |
| u | 7600588 | 6.2% |
| H | 6743404 | 5.5% |
| a | 6743404 | 5.5% |
| l | 6743404 | 5.5% |
| o | 5886220 | 4.8% |
| S | 5872159 | 4.8% |
| Other values (15) | 39589179 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 122224395 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 14358053 | 11.7% |
| 13486808 | 11.0% | |
| i | 7600588 | 6.2% |
| M | 7600588 | 6.2% |
| u | 7600588 | 6.2% |
| H | 6743404 | 5.5% |
| a | 6743404 | 5.5% |
| l | 6743404 | 5.5% |
| o | 5886220 | 4.8% |
| S | 5872159 | 4.8% |
| Other values (15) | 39589179 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 122224395 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 14358053 | 11.7% |
| 13486808 | 11.0% | |
| i | 7600588 | 6.2% |
| M | 7600588 | 6.2% |
| u | 7600588 | 6.2% |
| H | 6743404 | 5.5% |
| a | 6743404 | 5.5% |
| l | 6743404 | 5.5% |
| o | 5886220 | 4.8% |
| S | 5872159 | 4.8% |
| Other values (15) | 39589179 |
delay_carrier
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 1650 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.1698036 |
| Minimum | 0 |
|---|---|
| Maximum | 3957 |
| Zeros | 5955514 |
| Zeros (%) | 88.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 51.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 23 |
| Maximum | 3957 |
| Range | 3957 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 36.457324 |
|---|---|
| Coefficient of variation (CV) | 7.0519746 |
| Kurtosis | 861.84351 |
| Mean | 5.1698036 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 22.753561 |
| Sum | 34862074 |
| Variance | 1329.1364 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5955514 | |
| 1 | 25940 | 0.4% |
| 2 | 25697 | 0.4% |
| 3 | 24727 | 0.4% |
| 6 | 24624 | 0.4% |
| 4 | 23830 | 0.4% |
| 15 | 23740 | 0.4% |
| 7 | 22964 | 0.3% |
| 5 | 22733 | 0.3% |
| 8 | 21392 | 0.3% |
| Other values (1640) | 572243 | 8.5% |
| Value | Count | Frequency (%) |
| 0 | 5955514 | |
| 1 | 25940 | 0.4% |
| 2 | 25697 | 0.4% |
| 3 | 24727 | 0.4% |
| 4 | 23830 | 0.4% |
| 5 | 22733 | 0.3% |
| 6 | 24624 | 0.4% |
| 7 | 22964 | 0.3% |
| 8 | 21392 | 0.3% |
| 9 | 20398 | 0.3% |
| Value | Count | Frequency (%) |
| 3957 | 1 | |
| 3786 | 1 | |
| 3502 | 1 | |
| 3424 | 1 | |
| 3337 | 1 | |
| 3246 | 1 | |
| 3221 | 1 | |
| 3045 | 1 | |
| 3024 | 1 | |
| 2998 | 1 |
delay_weather
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 1073 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.7428505 |
| Minimum | 0 |
|---|---|
| Maximum | 1860 |
| Zeros | 6671405 |
| Zeros (%) | 98.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 51.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 1860 |
| Range | 1860 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 14.353928 |
|---|---|
| Coefficient of variation (CV) | 19.322768 |
| Kurtosis | 2949.5067 |
| Mean | 0.7428505 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 45.858291 |
| Sum | 5009341 |
| Variance | 206.03525 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 6671405 | |
| 15 | 1453 | < 0.1% |
| 16 | 1340 | < 0.1% |
| 6 | 1325 | < 0.1% |
| 17 | 1298 | < 0.1% |
| 7 | 1269 | < 0.1% |
| 18 | 1258 | < 0.1% |
| 10 | 1241 | < 0.1% |
| 19 | 1238 | < 0.1% |
| 8 | 1226 | < 0.1% |
| Other values (1063) | 60351 | 0.9% |
| Value | Count | Frequency (%) |
| 0 | 6671405 | |
| 1 | 1114 | < 0.1% |
| 2 | 1188 | < 0.1% |
| 3 | 1168 | < 0.1% |
| 4 | 1140 | < 0.1% |
| 5 | 1104 | < 0.1% |
| 6 | 1325 | < 0.1% |
| 7 | 1269 | < 0.1% |
| 8 | 1226 | < 0.1% |
| 9 | 1183 | < 0.1% |
| Value | Count | Frequency (%) |
| 1860 | 1 | |
| 1747 | 1 | |
| 1738 | 1 | |
| 1728 | 1 | |
| 1653 | 1 | |
| 1643 | 1 | |
| 1609 | 1 | |
| 1561 | 1 | |
| 1529 | 1 | |
| 1522 | 1 |
delay_nas
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 837 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.566957 |
| Minimum | 0 |
|---|---|
| Maximum | 1708 |
| Zeros | 6082619 |
| Zeros (%) | 90.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 51.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 16 |
| Maximum | 1708 |
| Range | 1708 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 15.004842 |
|---|---|
| Coefficient of variation (CV) | 5.8453812 |
| Kurtosis | 1142.3422 |
| Mean | 2.566957 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 22.646317 |
| Sum | 17310028 |
| Variance | 225.14529 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 6082619 | |
| 1 | 36929 | 0.5% |
| 2 | 26309 | 0.4% |
| 15 | 25623 | 0.4% |
| 3 | 24666 | 0.4% |
| 16 | 23136 | 0.3% |
| 4 | 23077 | 0.3% |
| 5 | 21730 | 0.3% |
| 17 | 21260 | 0.3% |
| 6 | 20248 | 0.3% |
| Other values (827) | 437807 | 6.5% |
| Value | Count | Frequency (%) |
| 0 | 6082619 | |
| 1 | 36929 | 0.5% |
| 2 | 26309 | 0.4% |
| 3 | 24666 | 0.4% |
| 4 | 23077 | 0.3% |
| 5 | 21730 | 0.3% |
| 6 | 20248 | 0.3% |
| 7 | 19252 | 0.3% |
| 8 | 18386 | 0.3% |
| 9 | 17266 | 0.3% |
| Value | Count | Frequency (%) |
| 1708 | 1 | |
| 1660 | 1 | |
| 1651 | 1 | |
| 1515 | 1 | |
| 1487 | 1 | |
| 1421 | 1 | |
| 1409 | 2 | |
| 1407 | 1 | |
| 1402 | 1 | |
| 1401 | 1 |
delay_security
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 201 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.030648764 |
| Minimum | 0 |
|---|---|
| Maximum | 1460 |
| Zeros | 6735256 |
| Zeros (%) | 99.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 51.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 1460 |
| Range | 1460 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.6289231 |
|---|---|
| Coefficient of variation (CV) | 53.148083 |
| Kurtosis | 179570.77 |
| Mean | 0.030648764 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 288.46433 |
| Sum | 206677 |
| Variance | 2.6533904 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 6735256 | |
| 15 | 333 | < 0.1% |
| 10 | 293 | < 0.1% |
| 16 | 291 | < 0.1% |
| 17 | 283 | < 0.1% |
| 8 | 270 | < 0.1% |
| 7 | 258 | < 0.1% |
| 12 | 257 | < 0.1% |
| 18 | 257 | < 0.1% |
| 9 | 256 | < 0.1% |
| Other values (191) | 5650 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 6735256 | |
| 1 | 184 | < 0.1% |
| 2 | 182 | < 0.1% |
| 3 | 200 | < 0.1% |
| 4 | 186 | < 0.1% |
| 5 | 243 | < 0.1% |
| 6 | 245 | < 0.1% |
| 7 | 258 | < 0.1% |
| 8 | 270 | < 0.1% |
| 9 | 256 | < 0.1% |
| Value | Count | Frequency (%) |
| 1460 | 1 | |
| 1183 | 1 | |
| 885 | 1 | |
| 808 | 1 | |
| 805 | 1 | |
| 600 | 1 | |
| 581 | 1 | |
| 449 | 1 | |
| 376 | 1 | |
| 373 | 1 |
delay_lastaircraft
Real number (ℝ)
ZEROS 
| Distinct | 1349 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.6811076 |
| Minimum | 0 |
|---|---|
| Maximum | 3581 |
| Zeros | 6032286 |
| Zeros (%) | 89.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 51.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 33 |
| Maximum | 3581 |
| Range | 3581 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 30.446469 |
|---|---|
| Coefficient of variation (CV) | 5.3592487 |
| Kurtosis | 537.39882 |
| Mean | 5.6811076 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 16.353585 |
| Sum | 38310004 |
| Variance | 926.98747 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 6032286 | |
| 15 | 17684 | 0.3% |
| 16 | 16691 | 0.2% |
| 17 | 15950 | 0.2% |
| 18 | 15240 | 0.2% |
| 19 | 14258 | 0.2% |
| 20 | 13982 | 0.2% |
| 21 | 13288 | 0.2% |
| 14 | 12685 | 0.2% |
| 22 | 12380 | 0.2% |
| Other values (1339) | 578960 | 8.6% |
| Value | Count | Frequency (%) |
| 0 | 6032286 | |
| 1 | 9092 | 0.1% |
| 2 | 9550 | 0.1% |
| 3 | 9331 | 0.1% |
| 4 | 9511 | 0.1% |
| 5 | 9753 | 0.1% |
| 6 | 10693 | 0.2% |
| 7 | 10528 | 0.2% |
| 8 | 10884 | 0.2% |
| 9 | 10977 | 0.2% |
| Value | Count | Frequency (%) |
| 3581 | 1 | |
| 3228 | 1 | |
| 2586 | 1 | |
| 2557 | 1 | |
| 2530 | 1 | |
| 2366 | 1 | |
| 2329 | 1 | |
| 2325 | 1 | |
| 2277 | 1 | |
| 2258 | 1 |
manufacturer
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 415.9 MiB |
| BOEING | |
|---|---|
| AIRBUS | |
| EMBRAER | |
| CANADAIR REGIONAL JET | |
| DIAMOND AIRCRAFT | 3 |
Length
| Max length | 21 |
|---|---|
| Median length | 6 |
| Mean length | 7.6746627 |
| Min length | 6 |
Characters and Unicode
| Total characters | 51753351 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CANADAIR REGIONAL JET |
|---|---|
| 2nd row | CANADAIR REGIONAL JET |
| 3rd row | CANADAIR REGIONAL JET |
| 4th row | CANADAIR REGIONAL JET |
| 5th row | CANADAIR REGIONAL JET |
Common Values
| Value | Count | Frequency (%) |
| BOEING | 3122320 | |
| AIRBUS | 1981786 | |
| EMBRAER | 949752 | 14.1% |
| CANADAIR REGIONAL JET | 689543 | 10.2% |
| DIAMOND AIRCRAFT | 3 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| boeing | 3122320 | |
| airbus | 1981786 | |
| embraer | 949752 | 11.7% |
| canadair | 689543 | 8.5% |
| regional | 689543 | 8.5% |
| jet | 689543 | 8.5% |
| diamond | 3 | < 0.1% |
| aircraft | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| I | 6483198 | |
| E | 6400910 | |
| B | 6053858 | |
| A | 5689719 | |
| R | 5260382 | |
| N | 4501409 | |
| O | 3811866 | |
| G | 3811863 | |
| S | 1981786 | 3.8% |
| U | 1981786 | 3.8% |
| Other values (8) | 5776574 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 51753351 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| I | 6483198 | |
| E | 6400910 | |
| B | 6053858 | |
| A | 5689719 | |
| R | 5260382 | |
| N | 4501409 | |
| O | 3811866 | |
| G | 3811863 | |
| S | 1981786 | 3.8% |
| U | 1981786 | 3.8% |
| Other values (8) | 5776574 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 51753351 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| I | 6483198 | |
| E | 6400910 | |
| B | 6053858 | |
| A | 5689719 | |
| R | 5260382 | |
| N | 4501409 | |
| O | 3811866 | |
| G | 3811863 | |
| S | 1981786 | 3.8% |
| U | 1981786 | 3.8% |
| Other values (8) | 5776574 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 51753351 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| I | 6483198 | |
| E | 6400910 | |
| B | 6053858 | |
| A | 5689719 | |
| R | 5260382 | |
| N | 4501409 | |
| O | 3811866 | |
| G | 3811863 | |
| S | 1981786 | 3.8% |
| U | 1981786 | 3.8% |
| Other values (8) | 5776574 |
model
Categorical
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 399.2 MiB |
| 737 NG | |
|---|---|
| 170/175 | |
| A320 | |
| A321 | |
| CRJ | |
| Other values (16) |
Length
| Max length | 10 |
|---|---|
| Median length | 7 |
| Mean length | 5.0740774 |
| Min length | 3 |
Characters and Unicode
| Total characters | 34216554 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CRJ |
|---|---|
| 2nd row | CRJ |
| 3rd row | CRJ |
| 4th row | CRJ |
| 5th row | CRJ |
Common Values
| Value | Count | Frequency (%) |
| 737 NG | 2703494 | |
| 170/175 | 863338 | 12.8% |
| A320 | 769279 | 11.4% |
| A321 | 704641 | 10.4% |
| CRJ | 689543 | 10.2% |
| A319 | 390607 | 5.8% |
| 717 | 184919 | 2.7% |
| 757 | 156147 | 2.3% |
| A220 | 98132 | 1.5% |
| 190/195 | 75262 | 1.1% |
| Other values (11) | 108042 | 1.6% |
Length
| Value | Count | Frequency (%) |
| 737 | 2720620 | |
| ng | 2703494 | |
| 170/175 | 863338 | 9.1% |
| a320 | 769310 | 8.1% |
| a321 | 704641 | 7.4% |
| crj | 689543 | 7.3% |
| a319 | 390607 | 4.1% |
| 717 | 184919 | 2.0% |
| 757 | 156147 | 1.7% |
| a220 | 98132 | 1.0% |
| Other values (10) | 179723 | 1.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 7 | 7999171 | |
| 3 | 4630542 | |
| 1 | 3179671 | 9.3% |
| 2717101 | 7.9% | |
| N | 2717070 | 7.9% |
| G | 2717070 | 7.9% |
| A | 1995365 | 5.8% |
| 0 | 1827501 | 5.3% |
| 2 | 1670215 | 4.9% |
| 5 | 1118671 | 3.3% |
| Other values (11) | 3644177 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 34216554 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 7 | 7999171 | |
| 3 | 4630542 | |
| 1 | 3179671 | 9.3% |
| 2717101 | 7.9% | |
| N | 2717070 | 7.9% |
| G | 2717070 | 7.9% |
| A | 1995365 | 5.8% |
| 0 | 1827501 | 5.3% |
| 2 | 1670215 | 4.9% |
| 5 | 1118671 | 3.3% |
| Other values (11) | 3644177 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 34216554 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 7 | 7999171 | |
| 3 | 4630542 | |
| 1 | 3179671 | 9.3% |
| 2717101 | 7.9% | |
| N | 2717070 | 7.9% |
| G | 2717070 | 7.9% |
| A | 1995365 | 5.8% |
| 0 | 1827501 | 5.3% |
| 2 | 1670215 | 4.9% |
| 5 | 1118671 | 3.3% |
| Other values (11) | 3644177 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 34216554 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 7 | 7999171 | |
| 3 | 4630542 | |
| 1 | 3179671 | 9.3% |
| 2717101 | 7.9% | |
| N | 2717070 | 7.9% |
| G | 2717070 | 7.9% |
| A | 1995365 | 5.8% |
| 0 | 1827501 | 5.3% |
| 2 | 1670215 | 4.9% |
| 5 | 1118671 | 3.3% |
| Other values (11) | 3644177 |
aicraft_age
Real number (ℝ)
| Distinct | 39 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.480626 |
| Minimum | 1 |
|---|---|
| Maximum | 57 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 51.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 7 |
| median | 12 |
| Q3 | 20 |
| 95-th percentile | 25 |
| Maximum | 57 |
| Range | 56 |
| Interquartile range (IQR) | 13 |
Descriptive statistics
| Standard deviation | 7.8914947 |
|---|---|
| Coefficient of variation (CV) | 0.58539525 |
| Kurtosis | -0.73164252 |
| Mean | 13.480626 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 0.29683421 |
| Sum | 90905310 |
| Variance | 62.275688 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8 | 403056 | 6.0% |
| 5 | 399399 | 5.9% |
| 23 | 379337 | 5.6% |
| 10 | 373106 | 5.5% |
| 7 | 355234 | 5.3% |
| 9 | 344489 | 5.1% |
| 6 | 330746 | 4.9% |
| 2 | 327333 | 4.9% |
| 24 | 313636 | 4.7% |
| 18 | 257439 | 3.8% |
| Other values (29) | 3259629 |
| Value | Count | Frequency (%) |
| 1 | 186073 | |
| 2 | 327333 | |
| 3 | 169787 | |
| 4 | 141338 | 2.1% |
| 5 | 399399 | |
| 6 | 330746 | |
| 7 | 355234 | |
| 8 | 403056 | |
| 9 | 344489 | |
| 10 | 373106 |
| Value | Count | Frequency (%) |
| 57 | 826 | < 0.1% |
| 56 | 1062 | < 0.1% |
| 48 | 2360 | < 0.1% |
| 39 | 645 | < 0.1% |
| 38 | 398 | < 0.1% |
| 34 | 9283 | 0.1% |
| 33 | 18807 | |
| 32 | 34391 | |
| 31 | 18053 | |
| 30 | 27339 |
| flightdate | day_of_week | airline | tail_number | dep_airport | dep_cityname | deptime_label | dep_delay | dep_delay_tag | dep_delay_type | arr_airport | arr_cityname | arr_delay | arr_delay_type | flight_duration | distance_type | delay_carrier | delay_weather | delay_nas | delay_security | delay_lastaircraft | manufacturer | model | aicraft_age | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2023-01-02 | 1 | Endeavor Air | N605LR | BDL | Hartford, CT | Morning | -3 | 0 | Low <5min | LGA | New York, NY | -12 | Low <5min | 56 | Short Haul >1500Mi | 0 | 0 | 0 | 0 | 0 | CANADAIR REGIONAL JET | CRJ | 16 |
| 1 | 2023-01-03 | 2 | Endeavor Air | N605LR | BDL | Hartford, CT | Morning | -5 | 0 | Low <5min | LGA | New York, NY | -8 | Low <5min | 62 | Short Haul >1500Mi | 0 | 0 | 0 | 0 | 0 | CANADAIR REGIONAL JET | CRJ | 16 |
| 2 | 2023-01-04 | 3 | Endeavor Air | N331PQ | BDL | Hartford, CT | Morning | -5 | 0 | Low <5min | LGA | New York, NY | -21 | Low <5min | 49 | Short Haul >1500Mi | 0 | 0 | 0 | 0 | 0 | CANADAIR REGIONAL JET | CRJ | 10 |
| 3 | 2023-01-05 | 4 | Endeavor Air | N906XJ | BDL | Hartford, CT | Morning | -6 | 0 | Low <5min | LGA | New York, NY | -17 | Low <5min | 54 | Short Haul >1500Mi | 0 | 0 | 0 | 0 | 0 | CANADAIR REGIONAL JET | CRJ | 17 |
| 4 | 2023-01-06 | 5 | Endeavor Air | N337PQ | BDL | Hartford, CT | Morning | -1 | 0 | Low <5min | LGA | New York, NY | -16 | Low <5min | 50 | Short Haul >1500Mi | 0 | 0 | 0 | 0 | 0 | CANADAIR REGIONAL JET | CRJ | 10 |
| 5 | 2023-01-07 | 6 | Endeavor Air | N336PQ | BDL | Hartford, CT | Morning | -10 | 0 | Low <5min | LGA | New York, NY | -13 | Low <5min | 62 | Short Haul >1500Mi | 0 | 0 | 0 | 0 | 0 | CANADAIR REGIONAL JET | CRJ | 10 |
| 6 | 2023-01-14 | 6 | Endeavor Air | N311PQ | LGA | New York, NY | Afternoon | -8 | 0 | Low <5min | CVG | Cincinnati, OH | -31 | Low <5min | 117 | Short Haul >1500Mi | 0 | 0 | 0 | 0 | 0 | CANADAIR REGIONAL JET | CRJ | 10 |
| 7 | 2023-01-21 | 6 | Endeavor Air | N917XJ | LGA | New York, NY | Afternoon | -10 | 0 | Low <5min | CVG | Cincinnati, OH | -25 | Low <5min | 125 | Short Haul >1500Mi | 0 | 0 | 0 | 0 | 0 | CANADAIR REGIONAL JET | CRJ | 16 |
| 8 | 2023-01-28 | 6 | Endeavor Air | N336PQ | LGA | New York, NY | Afternoon | -5 | 0 | Low <5min | CVG | Cincinnati, OH | -15 | Low <5min | 130 | Short Haul >1500Mi | 0 | 0 | 0 | 0 | 0 | CANADAIR REGIONAL JET | CRJ | 10 |
| 9 | 2023-01-09 | 1 | Endeavor Air | N491PX | LGA | New York, NY | Evening | -7 | 0 | Low <5min | BGM | Binghamton, NY | -3 | Low <5min | 63 | Short Haul >1500Mi | 0 | 0 | 0 | 0 | 0 | CANADAIR REGIONAL JET | CRJ | 4 |
| flightdate | day_of_week | airline | tail_number | dep_airport | dep_cityname | deptime_label | dep_delay | dep_delay_tag | dep_delay_type | arr_airport | arr_cityname | arr_delay | arr_delay_type | flight_duration | distance_type | delay_carrier | delay_weather | delay_nas | delay_security | delay_lastaircraft | manufacturer | model | aicraft_age | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6743394 | 2023-12-31 | 7 | JetBlue Airways | N937JB | BOS | Boston, MA | Afternoon | 60 | 1 | Medium >15min | BUF | Buffalo, NY | 43 | Medium >15min | 80 | Short Haul >1500Mi | 43 | 0 | 0 | 0 | 0 | AIRBUS | A321 | 10 |
| 6743395 | 2023-12-31 | 7 | JetBlue Airways | N945JT | SFO | San Francisco, CA | Morning | -8 | 0 | Low <5min | JFK | New York, NY | -14 | Low <5min | 326 | Medium Haul <3000Mi | 0 | 0 | 0 | 0 | 0 | AIRBUS | A321 | 10 |
| 6743396 | 2023-12-31 | 7 | JetBlue Airways | N558JB | ORH | Worcester, MA | Afternoon | -4 | 0 | Low <5min | FLL | Fort Lauderdale, FL | -35 | Low <5min | 169 | Short Haul >1500Mi | 0 | 0 | 0 | 0 | 0 | AIRBUS | A320 | 24 |
| 6743397 | 2023-12-31 | 7 | JetBlue Airways | N284JB | BOS | Boston, MA | Afternoon | -5 | 0 | Low <5min | BWI | Baltimore, MD | -20 | Low <5min | 85 | Short Haul >1500Mi | 0 | 0 | 0 | 0 | 0 | EMBRAER | 190/195 | 16 |
| 6743398 | 2023-12-31 | 7 | JetBlue Airways | N661JB | JFK | New York, NY | Morning | 20 | 1 | Medium >15min | RSW | Fort Myers, FL | -1 | Low <5min | 175 | Short Haul >1500Mi | 0 | 0 | 0 | 0 | 0 | AIRBUS | A320 | 17 |
| 6743399 | 2023-12-31 | 7 | JetBlue Airways | N903JB | SJU | San Juan, PR | Morning | 4 | 1 | Low <5min | JFK | New York, NY | -33 | Low <5min | 219 | Medium Haul <3000Mi | 0 | 0 | 0 | 0 | 0 | AIRBUS | A321 | 11 |
| 6743400 | 2023-12-31 | 7 | JetBlue Airways | N535JB | MCO | Orlando, FL | Evening | 113 | 1 | Hight >60min | SJU | San Juan, PR | 100 | Hight >60min | 162 | Short Haul >1500Mi | 4 | 0 | 0 | 0 | 96 | AIRBUS | A320 | 22 |
| 6743401 | 2023-12-31 | 7 | JetBlue Airways | N354JB | PHL | Philadelphia, PA | Afternoon | -11 | 0 | Low <5min | BOS | Boston, MA | -12 | Low <5min | 73 | Short Haul >1500Mi | 0 | 0 | 0 | 0 | 0 | EMBRAER | 190/195 | 11 |
| 6743402 | 2023-12-31 | 7 | JetBlue Airways | N768JB | PBI | West Palm Beach/Palm Beach, FL | Afternoon | -7 | 0 | Low <5min | BDL | Hartford, CT | -30 | Low <5min | 158 | Short Haul >1500Mi | 0 | 0 | 0 | 0 | 0 | AIRBUS | A320 | 15 |
| 6743403 | 2023-12-31 | 7 | JetBlue Airways | N547JB | BDL | Hartford, CT | Morning | -8 | 0 | Low <5min | PBI | West Palm Beach/Palm Beach, FL | -24 | Low <5min | 173 | Short Haul >1500Mi | 0 | 0 | 0 | 0 | 0 | AIRBUS | A320 | 22 |
Most frequently occurring
| flightdate | day_of_week | airline | tail_number | dep_airport | dep_cityname | deptime_label | dep_delay | dep_delay_tag | dep_delay_type | arr_airport | arr_cityname | arr_delay | arr_delay_type | flight_duration | distance_type | delay_carrier | delay_weather | delay_nas | delay_security | delay_lastaircraft | manufacturer | model | aicraft_age | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2023-01-11 | 3 | Southwest Airlines Co. | N8790Q | HNL | Honolulu, HI | Morning | 0 | 0 | Low <5min | ITO | Hilo, HI | -6 | Low <5min | 54 | Short Haul >1500Mi | 0 | 0 | 0 | 0 | 0 | BOEING | 737 NG | 2 | 2 |
| 1 | 2023-01-12 | 4 | Southwest Airlines Co. | N8715Q | HNL | Honolulu, HI | Morning | -2 | 0 | Low <5min | LIH | Lihue, HI | -5 | Low <5min | 42 | Short Haul >1500Mi | 0 | 0 | 0 | 0 | 0 | BOEING | 737 NG | 7 | 2 |
| 2 | 2023-01-23 | 1 | Southwest Airlines Co. | N8715Q | HNL | Honolulu, HI | Morning | -3 | 0 | Low <5min | ITO | Hilo, HI | -8 | Low <5min | 55 | Short Haul >1500Mi | 0 | 0 | 0 | 0 | 0 | BOEING | 737 NG | 7 | 2 |
| 3 | 2023-02-27 | 1 | Southwest Airlines Co. | N235WN | AUS | Austin, TX | Afternoon | -7 | 0 | Low <5min | DAL | Dallas, TX | -22 | Low <5min | 50 | Short Haul >1500Mi | 0 | 0 | 0 | 0 | 0 | BOEING | 737 NG | 18 | 2 |
| 4 | 2023-03-03 | 5 | Southwest Airlines Co. | N8787K | HNL | Honolulu, HI | Morning | -1 | 0 | Low <5min | OGG | Kahului, HI | -5 | Low <5min | 41 | Short Haul >1500Mi | 0 | 0 | 0 | 0 | 0 | BOEING | 737 NG | 2 | 2 |
| 5 | 2023-03-14 | 2 | Southwest Airlines Co. | N8546V | RIC | Richmond, VA | Afternoon | -7 | 0 | Low <5min | ATL | Atlanta, GA | -15 | Low <5min | 97 | Short Haul >1500Mi | 0 | 0 | 0 | 0 | 0 | BOEING | 737 NG | 7 | 2 |
| 6 | 2023-03-23 | 4 | Skywest Airlines Inc. | N823SK | SGU | St. George, UT | Morning | -6 | 0 | Low <5min | SLC | Salt Lake City, UT | -18 | Low <5min | 63 | Short Haul >1500Mi | 0 | 0 | 0 | 0 | 0 | CANADAIR REGIONAL JET | CRJ | 16 | 2 |
| 7 | 2023-04-11 | 2 | Skywest Airlines Inc. | N823SK | SLC | Salt Lake City, UT | Afternoon | -5 | 0 | Low <5min | SGU | St. George, UT | -13 | Low <5min | 60 | Short Haul >1500Mi | 0 | 0 | 0 | 0 | 0 | CANADAIR REGIONAL JET | CRJ | 16 | 2 |
| 8 | 2023-04-19 | 3 | Skywest Airlines Inc. | N823SK | SLC | Salt Lake City, UT | Afternoon | -3 | 0 | Low <5min | SGU | St. George, UT | -13 | Low <5min | 58 | Short Haul >1500Mi | 0 | 0 | 0 | 0 | 0 | CANADAIR REGIONAL JET | CRJ | 16 | 2 |
| 9 | 2023-05-06 | 6 | Republic Airways | N824MD | CMH | Columbus, OH | Morning | -4 | 0 | Low <5min | DTW | Detroit, MI | -25 | Low <5min | 49 | Short Haul >1500Mi | 0 | 0 | 0 | 0 | 0 | EMBRAER | 170/175 | 19 | 2 |